package edu.sjsu.cs.queryopt.dbms.dao;

public class PlanTable {

	public int queryBlockNo = 1; // Always 1
	
	public char accessType = 'R'; // 'R' Table space scan, 'I' Index scan, 'N' IN list index scan
	
	public int matchCols; // Number of matching columns in INDEX 
	public String accessName = ""; // Name of index
	public char indexOnly = 'N'; // 'Y' if index only access
	
	public char prefetch = ' '; // Blank - no prefetch, 'S' sequential prefetch
	public char sortC_orderBy = 'N'; // 'Y' if sort required
	
	public int table1Card; // Table 1 cardinality
	public int table2Card; // Table 2 cardinality
	
	public String leadTable; // leading outer table in NLJ
	public String innerTable; // new inner table in NLJ
}
